package net.bw.realtime.tmall.mapper;

import org.apache.ibatis.annotations.Select;

/*
 * @ Author：liuyawei
 * @ Date：2025-05-28
 */
public interface SaleCountStatsMapper {

    @Select("SELECT\n" +
            " sum(order_count) AS sale_count\n" +
            "FROM jtp_tmall_report.dws_order_count_window_report\n" +
            "WHERE toDate(window_start_time) = #{date}")
    Long selectSaleCount(String date);

}
